﻿CREATE TABLE [dbo].[vehicle] (
    [id]                  INT            IDENTITY (1, 1) NOT NULL,
    [id_type]             INT            NOT NULL,
    [gar_number]          NVARCHAR (MAX) NULL,
    [gos_number]          NVARCHAR (MAX) NULL,
    [name_type]           NVARCHAR (MAX) NULL,
    [id_main_fuel_type]   INT            NULL,
    [type_vehicle]        INT            NULL,
    [heater]              REAL           NULL,
    [lid_main_fuel_type]  BIT            NOT NULL,
    [ltype_vehicle]       BIT            NOT NULL,
    [lheater]             BIT            NOT NULL,
    [lfueltype]           BIT            NOT NULL,
    [kind_license_card]   INT            NOT NULL,
    [license_reg_number]  NVARCHAR (MAX) NOT NULL,
    [license_reg_serial]  NVARCHAR (MAX) NOT NULL,
    [license_number]      NVARCHAR (MAX) NOT NULL,
    [qnt_passenger]       INT            NOT NULL,
    [qnt_total_passenger] INT            NOT NULL,
	[del]   bit            NULL
    PRIMARY KEY CLUSTERED ([id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

